SUBROUTINE TABLE_S4
* Create a simple table using the RWS_TABLE routines and* populate it with data from a Reality file. Draw borders* round the cells. Right align the columns.* Include the RealWeb definitions.
INCLUDE #RW.INCLUDE.DEFS FROM /SYSFILES/REALWEB,BP
EQU LF TO CHAR(10)
EQU TAB TO CHAR(9)
EQU AM TO CHAR(254)
EQU VM TO CHAR(253)
* Get the URL of the Reality item server.
STYLESHEET = ""
CALL RW_GET_PARAM("__isurl", STYLESHEET)* Specify the location of the stylesheet.
STYLESHEET = STYLESHEET : "/REALWEB-ITEMS/blue.css"
* Start the HTML page.CALL RW_START_HTML_PAGE("RWS_Table with Reality Data Example 3", "", STYLESHEET, "", "")* Initialise the HTML string buffer.
HTML = ""
* Create a caption for the table.
TEXT = "Hotel Guests"
CALL RWS_TABLE_CAPTION(TEXT, "")
HTML = HTML : TEXT
* Assemble some data to go in the table.
PERFORM "SORT-SPREAD GUESTS < '200' " : ...
"ROOM NAME ADDRESS CITY STATE ZIP ID-SUPP" ...
CAPTURING aData
* The headings are in the second attribute.
DEL aData<1>
aHeadings = aData<1>
* SORT-SPREAD returns tab-separated data; we need a dynamic array.
aHeadings = CHANGE(aHeadings, TAB, AM)
* The data is in the third attribute onwards.
DEL aData<1>
* SORT-SPREAD returns tab-separated data; we need a dynamic array.
aData = CHANGE(aData, TAB, VM)
* For each heading...
FOR I = 1 TO DCOUNT(aHeadings , AM)
* Tag the text as a heading cell.
S = aHeadings<I>
CALL RWS_TABLE_HEADER(S, "")
aHeadings<I> = S
NEXT I
* Tag the attribute as a table row.CALL RWS_TABLE_ROW(aHeadings, "")
HTML = HTML : aHeadings
* For each data attribute...
FOR I = 1 TO DCOUNT(aData, AM)
* For each value in the attribute...
FOR J = 1 TO DCOUNT(aData<I>, VM)
* Right align the columns.
aClass = ""
aClass<2> = "RIGHT"
* Tag the text as a table cell.
S = aData<I,J>
CALL RWS_TABLE_DATA(S, aClass)
aData<I,J> = S
NEXT J
* Tag the attribute as a table row.
S = aData<I>
CALL RWS_TABLE_ROW(S, "")
aData<I> = S
NEXT I
HTML = HTML : aData
* Give the table a 5 pixel border.
aClass = ""
aClass<2> = "5"
* Make the internal rules 2 pixels wide.
aClass<3> = "2"
* Give the table a background colour.
aClass<4> = "cellspacing=0 cellpadding=5 bgcolor=lightsteelblue"
* Create the table.CALL RWS_TABLE(HTML, aClass)* Output the HTML.
HTML = CONVERT(HTML, AM:VM, LF:TAB)
CALL RW_PUT(HTML)* Complete the page.CALL RW_END_PAGE
RETURN
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><HTML><HEAD><META NAME="Generator" CONTENT="Reality"><TITLE>RWS_Table with Reality Data Example 3</TITLE><STYLE type="text/css"><!-- @import url(/servlet/realityis/test/REALWEB-ITEMS/blue.css); --></STYLE></HEAD><BODY><TABLE BORDER="5" RULES="2" cellspacing=0 cellpadding=5 bgcolor=lightsteelblue><CAPTION>Hotel Guests</CAPTION><TR><TH>Room</TH><TH>Guest Name</TH><TH>Address</TH><TH>City</TH><TH>State</TH><TH>Zip</TH></TR><TR><TD ALIGN="RIGHT">
117
</TD><TD ALIGN="RIGHT">
Loretta Rizzo
</TD><TD ALIGN="RIGHT">
10 Webster St.
</TD><TD ALIGN="RIGHT">
Harrington
</TD><TD ALIGN="RIGHT">
TX
</TD><TD ALIGN="RIGHT">
56634
</TD></TR><TR><TD ALIGN="RIGHT">
119
</TD><TD ALIGN="RIGHT">
Barry R. Scott
</TD><TD ALIGN="RIGHT">
90 Alpine St.
</TD><TD ALIGN="RIGHT">
Harrison
</TD><TD ALIGN="RIGHT">
CT
</TD><TD ALIGN="RIGHT">
66344
</TD></TR><TR><TD ALIGN="RIGHT">
122
</TD><TD ALIGN="RIGHT">
Richard T. Anderson
</TD><TD ALIGN="RIGHT">
153 Windsor Dr.
</TD><TD ALIGN="RIGHT">
Concord
</TD><TD ALIGN="RIGHT">
NH
</TD><TD ALIGN="RIGHT">
34598
</TD></TR><TR><TD ALIGN="RIGHT">
140
</TD><TD ALIGN="RIGHT">
Susan P. Lynch
</TD><TD ALIGN="RIGHT">
55 Hale Rd.
</TD><TD ALIGN="RIGHT">
Waltham
</TD><TD ALIGN="RIGHT">
NM
</TD><TD ALIGN="RIGHT">
22413
</TD></TR><TR><TD ALIGN="RIGHT">
142
</TD><TD ALIGN="RIGHT">
Jerry D. Madison
</TD><TD ALIGN="RIGHT">
27411 Trabuco Circle
</TD><TD ALIGN="RIGHT">
Mission Viejo
</TD><TD ALIGN="RIGHT">
CA
</TD><TD ALIGN="RIGHT">
92692
</TD></TR><TR><TD ALIGN="RIGHT">
143
</TD><TD ALIGN="RIGHT">
William Hennessey
</TD><TD ALIGN="RIGHT">
11 Ellison Rd.
</TD><TD ALIGN="RIGHT">
Lexington
</TD><TD ALIGN="RIGHT">
MA
</TD><TD ALIGN="RIGHT">
07745
</TD></TR><TR><TD ALIGN="RIGHT">
144
</TD><TD ALIGN="RIGHT">
Mr. & Mrs. H. Irving
</TD><TD ALIGN="RIGHT">
20 Thorpe Rd.
</TD><TD ALIGN="RIGHT">
Lexington
</TD><TD ALIGN="RIGHT">
FL
</TD><TD ALIGN="RIGHT">
28876
</TD></TR><TR><TD ALIGN="RIGHT">
147
</TD><TD ALIGN="RIGHT">
Loretta T. Janson
</TD><TD ALIGN="RIGHT">
23 Glenborn Av.
</TD><TD ALIGN="RIGHT">
Los Angeles
</TD><TD ALIGN="RIGHT">
CA
</TD><TD ALIGN="RIGHT">
07734
</TD></TR><TR><TD ALIGN="RIGHT">
194
</TD><TD ALIGN="RIGHT">
Mr. & Mrs. J. Hynes
</TD><TD ALIGN="RIGHT">
90 Harlow Ct.
</TD><TD ALIGN="RIGHT">
Stanton
</TD><TD ALIGN="RIGHT">
LA
</TD><TD ALIGN="RIGHT">
55278
</TD></TR><TR></TR></TABLE></BODY></HTML>